package com.showde.shoppingmall.db.constant;

/**
 * 地址
 * 
 * @author Kim
 * 
 */
public class AddressConstant extends ConstantBase {

	public static final String TABLENAME = "t_address";

	public static final String RECIPIENTID = "RECIPIENTID";
	public static final String COUNTRY = "COUNTRY"; // 国籍
	public static final String PROVINCE = "PROVINCE";// 省份
	public static final String CITY = "CITY"; // 城市
	public static final String STREET = "STREET"; // 街道
	public static final String AREA = "AREA";// 大厦
	public static final String DOORNUM = "DOORNUM";// 门牌号
	public static final String PHONENUM = "PHONENUM";// 手机号
	public static final String HOMENUM = "HOMENUM";// 家庭电话
	public static final String ADDRESSCONTENT = "ADDRESSCONTENT"; // 地址内容
	public static final String POSTCODE = "POSTCODE"; // 邮政编码
	public static final String RECIPIENT = "RECIPIENT";// 收件人
	public static final String TIME = "TIME"; // 地址编辑时间

	public static final int COLUMN_COUNTRY = 1; // 国籍
	public static final int COLUMN_PROVINCE = 2;// 省份
	public static final int COLUMN_CITY = 3; // 城市
	public static final int COLUMN_STREET = 4; // 街道
	public static final int COLUMN_BUILDING = 5;// 大厦
	public static final int COLUMN_DOORNUM = 6;// 门牌号
	public static final int COLUMN_PHONENUM = 7;// 手机号
	public static final int COLUMN_HOMENUM = 8;// 家庭电话
	public static final int COLUMN_ADDRESSCONTENT = 9; // 地址内容
	public static final int COLUMN_POSTCODE = 10; // 邮政编码
	public static final int COLUMN_RECIPIENT = 11;// 收件人
	public static final int COLUMN_TIME = 12; // 地址编辑时间

	public static final String[] dbColumns = new String[] { COUNTRY, PROVINCE,
			CITY, STREET, AREA, DOORNUM, PHONENUM, HOMENUM, POSTCODE,
			RECIPIENT, TIME };

	public static final String SQL_CREAT = "create table 't_address'("
			+ "'_id' primary key, " + "'RECIPIENTID' varchar(20),"
			+ "'COUNTRY' varchar(10)," + "'PROVINCE' varchar(20) not null,"
			+ "'CITY' varchar(20) not null," + "'STREET' varchar(50) not null,"
			+ "'AREA' varchar(20)," + "'DOORNUM' varchar(20),"
			+ "'PHONENUM' varchar(13)," + "'HOMENUM' varchar(13),"
			+ "'ADDRESSCONTENT' varchar(100)," + "'POSTCODE' varchar(10),"
			+ "'RECIPIENT' varchar(20) not null, 'TIME' timestamp" + ")";

}
